<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE topic
  PUBLIC "-//OASIS//DTD DITA Composite//EN" "ditabase.dtd">
<topic id="topic1" xml:lang="en"><title id="gc143896">pg_auth_members</title><body><p>The <codeph>pg_auth_members</codeph> system catalog table shows the membership relations between
      roles. Any non-circular set of relationships is allowed. Because roles are system-wide,
        <codeph>pg_auth_members</codeph> is shared across all databases of a Greenplum Database system.</p><table id="gc143898"><title>pg_catalog.pg_auth_members</title><tgroup cols="4"><colspec colnum="1" colname="col1" colwidth="131pt"/><colspec colnum="2" colname="col2" colwidth="86pt"/><colspec colnum="3" colname="col3" colwidth="85pt"/><colspec colnum="4" colname="col4" colwidth="147pt"/><thead><row><entry colname="col1">column</entry><entry colname="col2">type</entry><entry colname="col3">references</entry><entry colname="col4">description</entry></row></thead><tbody><row><entry colname="col1"><codeph>roleid</codeph></entry><entry colname="col2">oid</entry><entry colname="col3">pg_authid.oid</entry><entry colname="col4">ID of the parent-level (group) role</entry></row><row><entry colname="col1"><codeph>member</codeph></entry><entry colname="col2">oid</entry><entry colname="col3">pg_authid.oid</entry><entry colname="col4">ID of a member role</entry></row><row><entry colname="col1"><codeph>grantor</codeph></entry><entry colname="col2">oid</entry><entry colname="col3">pg_authid.oid</entry><entry colname="col4">ID of the role that granted this membership</entry></row><row><entry colname="col1"><codeph>admin_option</codeph></entry><entry colname="col2">boolean</entry><entry colname="col3"/><entry colname="col4">True if role member may grant membership to
others</entry></row></tbody></tgroup></table></body></topic>